/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 19/08/2025 16:55:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_property_company
-- ----------------------------
DROP TABLE IF EXISTS `sc_property_company`;
CREATE TABLE `sc_property_company` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '物业公司ID',
  `company_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公司名称',
  `company_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公司编码',
  `credit_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ç»Ÿä¸€ç¤¾ä¼šä¿¡ç”¨ä»£ç ',
  `business_license` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '营业执照号',
  `legal_representative` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '法定代表人',
  `contact_person` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系人',
  `contact_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系电话',
  `contact_email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系邮箱',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'é‚®ç®±åœ°å€',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司地址',
  `description` text COLLATE utf8mb4_unicode_ci COMMENT 'å…¬å¸ç®€ä»‹',
  `established_date` date DEFAULT NULL COMMENT '成立日期',
  `registered_capital` decimal(15,2) DEFAULT NULL COMMENT '注册资本(万元)',
  `service_scope` text COLLATE utf8mb4_unicode_ci COMMENT '服务范围',
  `qualification_level` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '资质等级',
  `payment_qr_code` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款二维码图片URL',
  `payment_account` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款账户',
  `payment_bank` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开户银行',
  `payment_link` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '在线支付链接',
  `wechat_pay_merchant_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信支付商户号',
  `alipay_merchant_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付宝商户号',
  `company_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司Logo',
  `introduction` text COLLATE utf8mb4_unicode_ci COMMENT '公司简介',
  `business_hours` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '营业时间',
  `service_hotline` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务热线',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：0-禁用，1-启用',
  `audit_status` tinyint(1) DEFAULT '0' COMMENT '审核状态：0-待审核，1-审核通过，2-审核拒绝',
  `audit_remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审核备注',
  `audit_by` bigint(20) DEFAULT NULL COMMENT '审核人ID',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序',
  `remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'å¤‡æ³¨',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `version` int(11) DEFAULT '1' COMMENT '版本号',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_company_code` (`company_code`),
  KEY `idx_company_name` (`company_name`),
  KEY `idx_status` (`status`),
  KEY `idx_audit_status` (`audit_status`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=1015 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='物业公司信息表';

-- ----------------------------
-- Records of sc_property_company
-- ----------------------------
BEGIN;
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1, '智慧社区物业服务有限公司', 'WISDOM001', NULL, 'L123456789012345678', '张三', '李四', '13800138001', 'contact@wisdom.com', NULL, '北京市朝阳区智慧大厦A座1001室', NULL, '2020-01-01', 1000.00, '住宅小区物业管理、商业物业管理、设施设备维护', '一级', NULL, '6222021234567890123', '中国工商银行北京分行', NULL, NULL, NULL, NULL, '智慧社区物业服务有限公司是一家专业的物业管理服务企业，致力于为业主提供优质的物业服务。', '周一至周日 8:00-18:00', '13800138002', 1, 1, NULL, 24, '2025-07-28 10:29:12', NULL, NULL, NULL, '2025-06-30 11:57:16', NULL, '2025-07-17 08:39:04', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (2, '智慧物业有限公司2', 'WZ001', 'WZ001', '123456789', 'WZ001', '张三', '13800138000', 'zhangsan@wz.com', 'zhangsan@wz.com', '北京市朝阳区xxx街道', 'description', NULL, 500.00, '住宅小区物业管理、商业物业管理、设施设备维护', '一级', NULL, '6222021234567890123', '中国工商银行北京分行', 'www.baidu.com', '6222021234567890123', '6222021234567890123', NULL, '智慧社区物业服务有限公司是一家专业的物业管理服务企业，致力于为业主提供优质的物业服务。', '周一至周日 8:00-18:00', '13800138002', 1, 1, '通过！', 24, '2025-07-17 15:36:09', NULL, NULL, NULL, '2025-06-30 12:16:57', NULL, '2025-08-11 03:55:32', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (3, '智慧物业有限公司', 'WZ002', NULL, '123456790', NULL, '李四', '13800138001', 'lisi@wz.com', NULL, '北京市海淀区xxx街道', NULL, NULL, NULL, NULL, '二级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, '不符合资质，不行', 24, '2025-07-17 14:56:14', NULL, NULL, NULL, '2025-06-30 12:29:03', NULL, '2025-07-12 14:40:26', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (4, '测试物业公司', 'TEST001', NULL, 'TEST123456', NULL, '测试人员', '13800138002', 'test@test.com', NULL, '测试地址', NULL, NULL, NULL, NULL, '三级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '审核通过！！！', 24, '2025-07-17 14:51:33', NULL, NULL, NULL, '2025-06-30 12:36:41', NULL, '2025-06-30 12:36:41', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1001, '测试物业公司A', 'TESTA001', NULL, 'BL123456A', '张总A', '联系人A', '13800000001', 'a@test.com', NULL, '北京市朝阳区A', NULL, '2022-01-01', NULL, NULL, '一级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, 0, NULL, 1, '2025-06-30 04:40:36', 1, '2025-06-30 04:40:36', 0, 1);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1002, '测试物业公司B', 'TESTB002', NULL, 'BL123456B', '张总B', '联系人B', '13800000002', 'b@test.com', NULL, '北京市海淀区B', NULL, '2022-02-01', NULL, NULL, '二级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, 0, NULL, 1, '2025-06-30 04:40:36', 1, '2025-06-30 04:40:36', 0, 1);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1003, '测试物业公司C', 'TESTC003', NULL, 'BL123456C', '张总C', '联系人C', '13800000003', 'c@test.com', NULL, '北京市丰台区C', NULL, '2022-03-01', NULL, NULL, '三级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, 0, NULL, 1, '2025-06-30 04:40:36', 1, '2025-06-30 04:40:36', 0, 1);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1005, '测试物业公司B', 'TEST002', NULL, NULL, NULL, '李四', '13800138002', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 'OK', 24, '2025-08-07 11:31:12', NULL, NULL, NULL, '2025-06-30 17:10:18', NULL, '2025-08-07 01:36:37', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1006, 'WuLiang测试公司一', 'WULIANGCESHIGONGSIYI', NULL, 'wuliangceshigongsiyi', 'wuliang', '吴樑一', '13567114713', '13567114713@qq.com', NULL, 'WuLiang测试公司一地址', NULL, NULL, NULL, '全部', '一级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '测试一', NULL, NULL, 1, 1, 'ok', 24, '2025-08-07 11:55:28', NULL, NULL, 1, '2025-08-07 10:40:11', 1, '2025-08-07 03:37:14', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1007, '吴樑测试公司01', 'WULIANGCESHIGONGSI01', NULL, 'WULIANGCESHIGONGSI01', 'WULIANG011', '吴樑', '13567114715', '13567114713@139.com', NULL, '吴樑测试公司01地址', NULL, NULL, NULL, 'all', '二级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '吴樑测试公司01', NULL, NULL, 1, 1, 'ok', 24, '2025-08-07 16:43:38', NULL, NULL, NULL, '2025-08-07 13:27:02', NULL, '2025-08-07 08:43:05', 0, 3);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1008, '吴樑测试公司02', 'WULIANGCESHIGONGSI02', NULL, 'WULIANGCESHIGONGSI02', 'WULIANG', '吴樑', '13567114714', '369222136@qq.com', NULL, '吴樑测试公司02地址', NULL, NULL, NULL, '全部', '三级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '吴樑测试公司02', NULL, NULL, 0, 0, 'ddd', 24, '2025-08-07 16:10:55', NULL, NULL, NULL, '2025-08-07 15:55:08', NULL, '2025-08-07 08:40:12', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1009, '吴樑测试公司03', 'WULIANGCESHIGONGSI03', NULL, 'WULIANGCESHIGONGSI03', '小瓜瓜', '小呱呱', '13567114712', '13567114712@139.com', NULL, '吴樑测试公司03', NULL, NULL, NULL, '全部', '二级', NULL, '13567114712@139.com', '322216549/7654654987', 'http://www.baidu.com', '468798456135464', '165498515', NULL, '吴樑测试公司03简介', '8:00', '13567114714', 1, 1, 'ok', 24, '2025-08-07 16:38:40', NULL, NULL, NULL, '2025-08-07 16:33:02', NULL, '2025-08-07 16:33:02', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1010, '吴樑测试公司04', 'WULIANGCESHIGONGSI04', NULL, 'WULIANGCESHIGONGSI04', '亮哥', 'wuliang2', '13800138000', '13800138000@139.com', NULL, '吴樑测试公司04地址', NULL, NULL, NULL, '吴樑测试公司04服务', '一级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '吴樑测试公司04简介', NULL, '13800138000', 1, 1, 'ok', 24, '2025-08-07 17:56:53', NULL, NULL, NULL, '2025-08-07 17:33:10', 34, '2025-08-19 09:32:58', 0, 6);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1011, '吴樑测试公司05', 'WULIANGCESHIGONGSI05', NULL, 'WULIANGCESHIGONGSI05', '吴樑', '胖胖', '13800138002', '13800138002@139.com', NULL, '吴樑测试公司05地址', NULL, NULL, NULL, '吴樑测试公司05范围', '一级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '吴樑测试公司05简介', NULL, '13800138002', 1, 1, 'ok', 24, '2025-08-08 12:55:21', NULL, NULL, NULL, '2025-08-08 10:10:08', NULL, '2025-08-08 10:10:08', 0, 2);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1012, '吴樑测试公司009', 'WULIANGCESHIGONGSI009', NULL, 'WULIANGCESHIGONGSI009', 'WULIANG', 'WULIANG', '13566666666', '13566666666@139.com', NULL, '吴樑测试公司009', NULL, NULL, NULL, '吴樑测试公司009', '一级', NULL, '44444444444444444444444444444444', NULL, NULL, '5555555555555555555555', NULL, NULL, NULL, NULL, NULL, 1, 1, '1', 24, '2025-08-08 16:16:43', NULL, NULL, NULL, '2025-08-08 16:14:38', 35, '2025-08-12 16:23:51', 0, 4);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1013, '小橘子有限公司', 'XIAOJUZIYOUXIANGONGSI', NULL, 'XIAOJUZIYOUXIANGONGSI', '小橘子', '小橘子', '18329188129', '18329188129@139.com', NULL, '小橘子有限公司地址', NULL, NULL, NULL, '全部', '一级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '无', NULL, NULL, 1, 1, 'OK!', 24, '2025-08-12 13:29:16', NULL, NULL, NULL, '2025-08-12 13:27:29', 32, '2025-08-12 13:55:21', 0, 4);
INSERT INTO `sc_property_company` (`id`, `company_name`, `company_code`, `credit_code`, `business_license`, `legal_representative`, `contact_person`, `contact_phone`, `contact_email`, `email`, `address`, `description`, `established_date`, `registered_capital`, `service_scope`, `qualification_level`, `payment_qr_code`, `payment_account`, `payment_bank`, `payment_link`, `wechat_pay_merchant_id`, `alipay_merchant_id`, `company_logo`, `introduction`, `business_hours`, `service_hotline`, `status`, `audit_status`, `audit_remark`, `audit_by`, `audit_time`, `sort_order`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (1014, '小橘子物业公司', 'XIAOJUZIWUYEGONGSI', NULL, 'XIAOJUZIWUYEGONGSI', '小橘子', '小橘子', '13566666666', '13566666666@139.com', NULL, '小橘子物业公司', NULL, NULL, NULL, NULL, '二级', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, 24, '2025-08-12 15:12:16', NULL, NULL, NULL, '2025-08-12 15:11:59', NULL, '2025-08-12 15:11:59', 0, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
